SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO
CREATE VIEW dbo._vwparticipantes
AS
SELECT     TOP 100 PERCENT Provincia, TipoParticipante, COUNT(IdParticipante) AS Expr1
FROM         dbo.vw_Participantes
GROUP BY Provincia, TipoParticipante, IdInstancia
HAVING      (IdInstancia = 4001)
ORDER BY Provincia, TipoParticipante
GO
